Title: SQL W3S (By-BKK) / 003 Select
Tags: Obsidian_to_Anki

Q: What does the SQL SELECT statement do?
A: It selects data from a database

Q: Which clause specifies the table to select data from?
A: FROM

Q: True/False: SELECT * returns only one column
A: False

Q: How can you select all columns from a table?
A: Use SELECT * FROM table_name

Q: What is the syntax to select two columns from 'Customers'?
A: SELECT column1, column2 FROM Customers

Q: Which field names do you use in SELECT?
A: The field names of the table you want data from

Q: What does table_name represent in a SELECT query?
A: The name of the table to select data from

Q: CustomerName and City are examples of what in a SELECT query?
A: Column names

Q: True/False: You must specify every column to select all columns
A: False

Q: Which table is used as a demo in W3Schools SQL examples?
A: Customers

Q: SELECT * FROM table_name
A: How can you select all columns from a table?

Q: It selects data from a database
A: What does the SQL SELECT statement do?